package com.cw.entity;

import java.math.BigDecimal;
import com.baomidou.mybatisplus.annotation.TableName;
import java.time.LocalDateTime;
import com.baomidou.mybatisplus.annotation.TableField;
import java.io.Serializable;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import com.alibaba.excel.annotation.ExcelProperty;

/**
 * @author ly
 * @since 2021-08-16
 */
@ApiModel(value ="")
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("PACS55.TOAD_PLAN_TABLE")
public class ToadPlanTable implements Serializable {

    private static final long serialVersionUID = 1L;

    @ExcelProperty(value = "STATEMENT_ID")
    @TableField("STATEMENT_ID")
    private String statementId;

    @ExcelProperty(value = "PLAN_ID")
    @TableField("PLAN_ID")
    private BigDecimal planId;

    @ExcelProperty(value = "TIMESTAMP")
    @TableField("TIMESTAMP")
    private LocalDateTime timestamp;

    @ExcelProperty(value = "REMARKS")
    @TableField("REMARKS")
    private String remarks;

    @ExcelProperty(value = "OPERATION")
    @TableField("OPERATION")
    private String operation;

    @ExcelProperty(value = "OPTIONS")
    @TableField("OPTIONS")
    private String options;

    @ExcelProperty(value = "OBJECT_NODE")
    @TableField("OBJECT_NODE")
    private String objectNode;

    @ExcelProperty(value = "OBJECT_OWNER")
    @TableField("OBJECT_OWNER")
    private String objectOwner;

    @ExcelProperty(value = "OBJECT_NAME")
    @TableField("OBJECT_NAME")
    private String objectName;

    @ExcelProperty(value = "OBJECT_ALIAS")
    @TableField("OBJECT_ALIAS")
    private String objectAlias;

    @ExcelProperty(value = "OBJECT_INSTANCE")
    @TableField("OBJECT_INSTANCE")
    private BigDecimal objectInstance;

    @ExcelProperty(value = "OBJECT_TYPE")
    @TableField("OBJECT_TYPE")
    private String objectType;

    @ExcelProperty(value = "OPTIMIZER")
    @TableField("OPTIMIZER")
    private String optimizer;

    @ExcelProperty(value = "SEARCH_COLUMNS")
    @TableField("SEARCH_COLUMNS")
    private BigDecimal searchColumns;

    @ExcelProperty(value = "PARENT_ID")
    @TableField("PARENT_ID")
    private BigDecimal parentId;

    @ExcelProperty(value = "DEPTH")
    @TableField("DEPTH")
    private BigDecimal depth;

    @ExcelProperty(value = "POSITION")
    @TableField("POSITION")
    private BigDecimal position;

    @ExcelProperty(value = "COST")
    @TableField("COST")
    private BigDecimal cost;

    @ExcelProperty(value = "CARDINALITY")
    @TableField("CARDINALITY")
    private BigDecimal cardinality;

    @ExcelProperty(value = "BYTES")
    @TableField("BYTES")
    private BigDecimal bytes;

    @ExcelProperty(value = "OTHER_TAG")
    @TableField("OTHER_TAG")
    private String otherTag;

    @ExcelProperty(value = "PARTITION_START")
    @TableField("PARTITION_START")
    private String partitionStart;

    @ExcelProperty(value = "PARTITION_STOP")
    @TableField("PARTITION_STOP")
    private String partitionStop;

    @ExcelProperty(value = "PARTITION_ID")
    @TableField("PARTITION_ID")
    private BigDecimal partitionId;

    @ExcelProperty(value = "OTHER")
    @TableField("OTHER")
    private String other;

    @ExcelProperty(value = "DISTRIBUTION")
    @TableField("DISTRIBUTION")
    private String distribution;

    @ExcelProperty(value = "CPU_COST")
    @TableField("CPU_COST")
    private BigDecimal cpuCost;

    @ExcelProperty(value = "IO_COST")
    @TableField("IO_COST")
    private BigDecimal ioCost;

    @ExcelProperty(value = "TEMP_SPACE")
    @TableField("TEMP_SPACE")
    private BigDecimal tempSpace;

    @ExcelProperty(value = "ACCESS_PREDICATES")
    @TableField("ACCESS_PREDICATES")
    private String accessPredicates;

    @ExcelProperty(value = "FILTER_PREDICATES")
    @TableField("FILTER_PREDICATES")
    private String filterPredicates;

    @ExcelProperty(value = "PROJECTION")
    @TableField("PROJECTION")
    private String projection;

    @ExcelProperty(value = "TIME")
    @TableField("TIME")
    private BigDecimal time;

    @ExcelProperty(value = "QBLOCK_NAME")
    @TableField("QBLOCK_NAME")
    private String qblockName;

    @ExcelProperty(value = "OTHER_XML")
    @TableField("OTHER_XML")
    private String otherXml;



}
